class UserMapper:
    ADD_USER = """INSERT INTO `aoa_user`(`address`, `hire_time`, `user_idcard`, `img_path`, `is_lock`, `password`, `real_name`, `user_school`, `sex`, `theme_skin`, `user_edu`, `user_name`, `user_tel`, `dept_id`, `position_id`, `role_id`,  `pinyin`)
                                VALUES ('{address}','{job_time}',"{user_idcard}","",0,"{password}","{real_name}","{user_school}",'{sex}',"yellow","{user_edu}","{user_name}","{user_tel}","{dept_id}","{position_id}","{role_id}","{pinyin}")"""

    GET_BY_USER_NAME = "select user_id FROM `aoa_user` WHERE user_name='{user_name}'"